package com.aierkeji.b2c.dao.jpa;

import java.util.Date;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.aierkeji.b2c.dao.BaseJPADao;
import com.aierkeji.b2c.entity.AkjSmsRecord;

public interface AkjSmsRecordDao extends BaseJPADao<AkjSmsRecord, String>{

	@Query("SELECT COUNT(1) FROM AkjSmsRecord where ip = :id and createdAt>=:createdAt")
	public int countByIp(@Param("id")String id,@Param("createdAt")Date createdAt);
}
